Urgent..help me

Discussions

EJB programming & troubleshooting: Urgent..help me

  1. Urgent..help me (3 messages)

    Hello All
      how 2 create a database table in cloudscape i couldn't find it neither in J2sdkee documentation nor in sun site its just mentioned how 2 create a table, but i want it in Cloudscape.....
      waiting 4 ur fastest mail

    regards
    Nancy

    Threaded Messages (3)

  2. Urgent..help me[ Go to top ]

    hi
    u can create table in cloudscape only through a java program write a simple java program of making a copnnection to database and and creating a table through a sql query
    thanx
  3. Urgent..help me[ Go to top ]


    yes u can refer to monica pawal pdf at sun's site
    however u have to create 2 files create.sql and cd.bat

    create.sql--->
    drop table accounts;

    create table accounts (id varchar(64), ownername varchar(64) , balance numeric(18));
    exit;


    cd.bat---->
    java -Dij.connection.CloudscapeDB=jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB\;create=true
    %JAVA_HOME%\bin\java -Dcloudscape.system.home=%J2EE_HOME%\cloudscape -classpath %J2EE_HOME%\lib\cloudscape\tools.jar;%J2EE_HOME%\lib\cloudscape\cloudscape.jar;%J2EE_HOME%\lib\cloudscape\RmiJdbc.jar;%J2EE_HOME%\lib\cloudscape\license.jar -ms16m -mx32m RmiJdbc.RJJdbcServer COM.Cloudscape.tools.ij create.sql

    i hope this will work

    don't forget to set JAVA_HOME,J2EE_HOME

    hope this will work

    somal

  4. Urgent..help me[ Go to top ]

    i had done exactly what u said , but am getting

    Caught Exception !
    javax.ejb.CreateException:java.sql.SQLException: The URL cannot be null
    Destroying Account...
    Mallik