DATABASE ERROR: java.sql.SQLException: Invalid argument(s) in call

[Y Jadhav]

This error in stdout...when trying to connect to Database oracle 10g.

please help me sir???

 
1281 [Thread-1] ERROR: hbm2ddl.SchemaUpdate - could not complete schema update
org.hibernate.exception.GenericJDBCException: could not get table metadata: tutorials..
:
:
Caused by: java.sql.SQLException: Invalid argument(s) in call
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
:
:
   

[Alaa Nassef]

Since it's a hibernate exception, I believe that this should belong to the ORM forum. Another thing, please provide us with the code that caused the error, and the full stack trace.

[Mark Spritzler]

Moving this to the ORM forum.

When this is moved, can you post your mappings, it seems to connect to Oracle. It looks like it is trying to update a tutorials table, but that table doesn't exist in your database.

Mark

[Y Jadhav]

Thanks sir ,
Sorry I have been on holidays...thats why couldnt send reply..

these are mapping file for DB.


struts-config.xml

 
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
    <set-property
      property="driverClassName"
      value="oracle.jdbc.OracleDriver" />
    <set-property
      property="url"
      value="jdbc :-o	 racle:thin:@optimatr-284aa9:1521:xe" />
    <set-property
      property="username"
      value="system" />
    <set-property
      property="password"
      value="12984" />
    <set-property
      property="maxActive"
      value="10" />
    <set-property
      property="maxWait"
      value="5000" />
    <set-property
      property="defaultAutoCommit"
      value="false" />
    <set-property
      property="defaultReadOnly"
      value="false" />
    <set-property
      property="validationQuery"
      value="SELECT COUNT(*) FROM market" />
</data-source>
</data-sources>
   

hibernate.hbm.xml

   
 
<hibernate-configuration>
   <session-factory>
   <property name="connection.datasource">java:comp/env/jdbc/Sampdb </property>
   <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
   <property name="connection.driver_class">oracle.jdbc.OracleDriver</property>
   <property name="connection.username">system</property>
   <property name="connection.password">12984</property>
   <property name="connection.url">jdbc :-o	 racle:thin:@optimatr-284aa9:1521:xe</property>
   <property name="show_sql">true</property>
   <property name="">true</property>
   <mapping resource="/com/strutsrecipes/hibernate/beans/Element.hbm.xml"/>
</session-factory>
</hibernate-configuration>
 

tutorials.hbm.xml

  <hibernate-mapping auto-import="true" default-lazy="false">
 
<class 
    name="roseindia.net.dao.hibernate.Tutorial" 
    table="tutorials"
>
 
    <id
        name="id"
        type="java.lang.Integer"
        column="id"
    >
        <generator class="increment" />
    </id>
 
    <property
        name="shortdesc"
        type="java.lang.String"
        column="shortdesc"
        not-null="true"
        length="50"
    />
    <property
        name="longdesc"
        type="java.lang.String"
        column="longdesc"
        not-null="true"
        length="250"
    />
    <property
        name="pageurl"
        type="java.lang.String"
        column="pageurl"
        not-null="true"
        length="100"
    />
 
  
 
</class>
</hibernate-mapping>
  

These three are mapping files , if you need any other details please tell me,

Thank you SIR.

[Y Jadhav]

Also this what error is there in my catalina.log file...


Oct 15, 2008 12:08:13 PM org.apache.catalina.core.NamingContextListener addResource
WARNING: Failed to register in JMX: javax.naming.NamingException: Could not load resource factory class [Root exception is java.lang.ClassNotFoundException: org.apache.commons.dbcp.BasicDataSourceFactory]