Hi
this error is coming in the server.log file when i m trying to login.
What does this mean. In my database i could see 26 tables. How many are
required??
2007-06-12 12:57:59,890 ERROR [org.jboss.portal.server.servlet.PortalServlet]
Unexpected exception
java.lang.NullPointerException
You are definitely missing some tables. No use in trying to login before the db
schema is set up properly.
I'd suggest to clean your database by deleting all tables first. Then follow
Prabhats last advice to force Hibernate to use the Sybase dialect by changing
this in all hibernate.cfg.xml
In all hibernate.cfg.xml files I have already made an entry of dialect.
I have tried both the dialect properties
1 : org.hibernate.dialect.SybaseAnywhereDialect
2: org.hibernate.dialect.SybaseDialect
These errors are coming after that only.
View the original post :
ok. have you checked the log which tables were not created?
also, have you looked at the jira issue related to sybase already linked to by
Prabhat: http://jira.jboss.com/jira/browse/JBPORTAL-304? You might have the
same problem.
View the original post :
Could not create table with SQL: CREATE CACHED TABLE JMS_MESSAGES ( MESSAGEID
INTEGER NOT NULL, DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP
CHAR(1), MESSAGEBLOB OBJECT, PRIMARY KEY (MESSAGEID, DESTINATION) )
Could not create table with SQL: CREATE CACHED TABLE JMS_TRANSACTIONS ( TXID
In your deploy folder, when you put portal-sybase-ds.xml, did you delete
hsqldb-ds.xml? hsqldb-ds.xml is needed for JMS to work. If you want JMS to also
use sybase, then more work is needed but I don't think you would want to do
that at this stage. So, please restore hsqldb-ds.xml and before
I have 2 *-ds.xml files.
1 portal-sybase-ds.xml
2 hsqldb-ds.xml
I have changed nothing in hsqldb-ds.xml.
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4053795#4053795
Reply to the post :
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4053795
Hello,
All tables are not getting created when first time after creating database
I'm starting the server. Thats why I am not able to log in. Why is this problem
coming?
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4052986#4052986
Reply to the post :
Do you see any error in server\default\log\server.log related to not being able
to create a table?
I think with syabse, hinbernate many not be picking up dialect correctly.
Please try explicitly forcing hibernate dialect in all hibernate.cfg.xml files
under jboss-portal.sar. See
To support of my previous reply
This is what i m getting as an error--
13:01:20,017 WARN [JDBCExceptionReporter] SQL Error: 2706, SQLState: 42W33
13:01:20,017 ERROR [JDBCExceptionReporter] ASA Error -141: Table 'JBP_INSTANCE'
not found
13:01:20,017 ERROR [PortletAppDeployment]
Hello,
Now I m getting Connection refused error.
Errors--
--- MBeans waiting for other MBeans ---
ObjectName: portal:service=Hibernate
State: FAILED
Reason: org.jboss.util.NestedSQLException: Could not create connection; - nest
ed throwable: (java.sql.SQLException: JZ006: Caught
That's something you have to figure out on your side. Do you have firewall
blocking this? Is sybase running on that port? Can you see that port being used?
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4051705#4051705
Reply to the post :
hello,
There is some progress. Now i can connect to the database but when I type in
the url localhost:8080/portal/portal then I can see the 1st page of login and
all, But when I try to login it gives Null pointer exception.
Why is that coming? IS it bcoz the tables are not getting created
I have a jar called jconn2.jar in my jboss/server/default/lib folder.
Is it the correct jar???
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4051239#4051239
Reply to the post :
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4051239
Well, the best way to find will be to look into jar and see if it has the class
you are using.
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4051320#4051320
Reply to the post :
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4051320
I have already checked that. Its is there.
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4051588#4051588
Reply to the post :
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4051588
___
jboss-user
what is that dialect?? Should i change it?? how?
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4050814#4050814
Reply to the post :
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4050814
___
Once you have correct -ds.xml, in most cases you would not have to set
hibernate dialect. But if you are getting error related to hibernate not being
able to pick correct dialect, please explicitly change dialects in all
hibernate.cfg.xml under jboss-portal.sar/**/
View the original post :
Thanks for your reply.
I have made those changes.
But still of new use. Its not working still.
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4050926#4050926
Reply to the post :
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4050926
Can you send me a lit of *-ds.xml you have in deploy folder, paste contents of
portal*-ds.xml and error that you are getting?
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4050931#4050931
Reply to the post :
This is my portal-sybase-ds.xml file.
?xml version=1.0 encoding=UTF-8?
local-tx-datasource
jndi-namePortalDS/jndi-name
connection-urljdbc:sybase:Tds:cc3:5000/jbossportal/connection-url
driver-classcom.sybase.jdbc2.jdbc.SybDataSource/driver-class
user-nameadmin/user-name
The only thing I can think of type-mapping element in portal-sybase-ds.xml. I
dont think that's needed. Little googling suggests that that's probably
required for CMP. This is how mine looks like for MySql and this works:
local-tx-datasource
jndi-namePortalDS/jndi-name
hi
thanks for your reply...
I tried what you said. This time some different exceptions are coming.
No classloaders found for sybase
Exception-
Caused by: org.jboss.resource.JBossResourceException: Could not create connectio
n; - nested throwable:
You dont have jdbc driver jar in lib folder. I think it will help you a lot if
you go through portal document once.
Please put jar containing com.sybase.jdbc2.jdbc.SybaseDataSource in
jboss-4.0.5-GA/server/default/lib and this error will go away.
View the original post :
These are the errors I m getting when i'm starting my Jboss
16:08:54,773 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
--- Incompletely deployed packages ---
[EMAIL PROTECTED] { url=file:/D:/jboss-portal-
/server/default/deploy/portal-sybase-ds.xml }
deployer: [EMAIL PROTECTED]
yes it is PortalDS only.
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4050536#4050536
Reply to the post :
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4050536
___
jboss-user mailing list
Hibernate is not a database, it can *use* pretty much any database.
You just need to define the datasource descriptor and add the JDBC driver of
sybase in server/default/lib.
See the JBoss Portal documentation:
http://docs.jboss.com/jbportal/v2.6/reference-guide/en/html/installation.html#d0e672
Thanks for your reply.
But I am not quite comfertable with the 3rd step.
Deploy Your JDBC Connector
What am i supposed to do in it?? Please explain..
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4050093#4050093
Reply to the post :
Get the JDBC driver for Sybase (it's a jar) then put it in:
JBOSS_INSTALL_DIRECTORY/server/default/lib/
See Sybase documentation if you cannot find it.
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4050097#4050097
Reply to the post :
Ok. Now I got the jar file called jtds-1.2.jar and I copied it in the lib
folder of my jboss installation directory.
But I m not getting which xml file i should change and how?
Sorry but I m new to Porlets and sybase also.
Thanks.
View the original post :
30 matches
Mail list logo