You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Vladimir Figurov <vf...@asia-soft.kz> on 2005/10/28 09:37:24 UTC
J2 - How to connect another DB, not HSQLDB ?
hi.
I try use is Oracle with J2.
I find on
http://people.apache.org/~raphael/j2forrest/user-docs/database.html,
that need make next steps:
1) include in your $HOME/build.properties addon properties - (I uncluded)
2) run next scripts:
maven db.scripts.gen
maven dropdrops
maven db.create.test
maven db.create.production
but, on Ferst maven scripts I see err. mess:
BUILD FAILED
Goal "db.scripts.gen" does not exist in this project.
What is wrong?
--
Vladimir
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: J2 - How to connect another DB, not HSQLDB ?
Posted by Randy Watler <wa...@wispertel.net>.
Vladimir,
Seems that you DB is not configured correctly. Please check url and
parameteres on Tomcat context file. If your webapp is actually named
java-portal, look for
$TOMCAT_HOME/conf/Catalina/localhost/java-portal.xml. The webapp is
normally called jetspeed, so the context would be jetspeed.xml, (it
appears that you have a custom portal app configuration since you are
using http://localhost/java-portal to access it).
HTH,
Randy
Vladimir Figurov wrote:
> Attempt work with Oracle. Next error:
>
> After manual correct "populate-userinfo-for-default-psml.sql" file in
> Local source and run then:
> >maven initMavenPlugin -o
> >maven -o j2:portal.genapp
> >maven war:install -o
> >maven j2:quickStart -o
>
> I have in Tomcat my build j2. But!!! On startup tomcat I view on his
> LOG error messages about PAM applications.
>
> After navigate browser on http://localhost/java-portal/ I view, that:
> - PAM portlet is not work
> - and DB Browser portlet writed: "java.lang.Exception: Failed to
> connect, Cannot create PoolableConnectionFactory (Connection is
> broken: Connection refused: connect)"
>
>
> On including HSQLDB - not this errors... 8-(
>
> Where I can look for repair????
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: J2 - How to connect another DB, not HSQLDB ?
Posted by Vladimir Figurov <vf...@asia-soft.kz>.
Attempt work with Oracle. Next error:
After manual correct "populate-userinfo-for-default-psml.sql" file in
Local source and run then:
>maven initMavenPlugin -o
>maven -o j2:portal.genapp
>maven war:install -o
>maven j2:quickStart -o
I have in Tomcat my build j2. But!!! On startup tomcat I view on his LOG
error messages about PAM applications.
After navigate browser on http://localhost/java-portal/ I view, that:
- PAM portlet is not work
- and DB Browser portlet writed: "java.lang.Exception: Failed to
connect, Cannot create PoolableConnectionFactory (Connection is broken:
Connection refused: connect)"
On including HSQLDB - not this errors... 8-(
Where I can look for repair????
--
Vladimir
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: J2 - How to connect another DB, not HSQLDB ?
Posted by James Liao <ji...@gmail.com>.
Hi,
I had reported this problem a few hours ago. I think J2 team will fix it
soon..
-James Liao
On 10/28/05, Vladimir Figurov <vf...@asia-soft.kz> wrote:
>
> yes, while I wait answer on this quest, I find in maven's .xml that,
> goal "j2:quickStart" is including goal for build "custom" DB.
>
> I get next error in during execute "j2:quickStart" :
>
> j2:_db.execute:
> [sql] Executing file:
> C:\work\web\J2\java-soft\target\portal-sql\oracle\populate-
> userinfo-for-default-psml.sql
> [sql] [ERROR] Failed to execute: INSERT INTO SECURITY_PERMISSION
> VALUES(100,'org.apache.jetspeed.security.PortletPermission
> ','security::*','view,
> edit'
> ,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572')
>
> BUILD FAILED
> File...... C:\Documents and
> Settings\Bob\.maven\cache\maven-
> jetspeed2-plugin-2.0-M4-SNAPSHOT\plugin.jelly
> Element... sql
> Line...... 842
> Column.... 44
> java.sql.SQLException: ORA-01843: ьхё Ў эхтхЁхэ
>
>
> if view this script (populate-userinfo-for-default-psml.sql), you find
> error - FORMAT STRING is empty 8-(
>
> anybody will correct this err?
>
>
>
>
> Randy Watler wrote:
>
> > The maven goal names have changed recently.
> >
> > Please see the website for details under "Maven Plugin".
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> > For additional commands, e-mail: jetspeed-user-help@portals.apache.org
> >
> >
>
>
> --
> Владимир Фигуров
> ТОО "АЗИЯ-СОФТ"
> Департамент разработки
> ведущий специалист
> ICQ: 332054482
> офис: 8-3272-754400
> моб: 8-300-7270789
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
Re: J2 - How to connect another DB, not HSQLDB ?
Posted by Vladimir Figurov <vf...@asia-soft.kz>.
yes, while I wait answer on this quest, I find in maven's .xml that,
goal "j2:quickStart" is including goal for build "custom" DB.
I get next error in during execute "j2:quickStart" :
j2:_db.execute:
[sql] Executing file:
C:\work\web\J2\java-soft\target\portal-sql\oracle\populate-userinfo-for-default-psml.sql
[sql] [ERROR] Failed to execute: INSERT INTO SECURITY_PERMISSION
VALUES(100,'org.apache.jetspeed.security.PortletPermission','security::*','view,
edit'
,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572')
BUILD FAILED
File...... C:\Documents and
Settings\Bob\.maven\cache\maven-jetspeed2-plugin-2.0-M4-SNAPSHOT\plugin.jelly
Element... sql
Line...... 842
Column.... 44
java.sql.SQLException: ORA-01843: ьхё Ў эхтхЁхэ
if view this script (populate-userinfo-for-default-psml.sql), you find
error - FORMAT STRING is empty 8-(
anybody will correct this err?
Randy Watler wrote:
> The maven goal names have changed recently.
>
> Please see the website for details under "Maven Plugin".
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
--
Владимир Фигуров
ТОО "АЗИЯ-СОФТ"
Департамент разработки
ведущий специалист
ICQ: 332054482
офис: 8-3272-754400
моб: 8-300-7270789
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: J2 - How to connect another DB, not HSQLDB ?
Posted by Randy Watler <wa...@wispertel.net>.
The maven goal names have changed recently.
Please see the website for details under "Maven Plugin".
HTH,
Randy
Vladimir Figurov wrote:
> hi.
> I try use is Oracle with J2.
> I find on
> http://people.apache.org/~raphael/j2forrest/user-docs/database.html,
> that need make next steps:
> 1) include in your $HOME/build.properties addon properties - (I uncluded)
> 2) run next scripts:
>
> maven db.scripts.gen
> maven dropdrops
> maven db.create.test
> maven db.create.production
>
>
> but, on Ferst maven scripts I see err. mess:
>
> BUILD FAILED
> Goal "db.scripts.gen" does not exist in this project.
>
> What is wrong?
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org